<?php

/*
 * Created on 2010-1-17
 */

$db_host = "localhost";
$db_database = "homeworksubmit";
$db_username = "root";
$db_password = "";
$db_ut = "utf8";
$upload_path = "d:/";


$global_test=0;
$db = new mysql($db_host, $db_username, $db_password, $db_database, $db_ut);

/*
* to do: reg exp 
*/
function getContext() {
	return;
}

class mysql {

	private $host;
	private $name;
	private $pass;
	private $table;
	private $ut;

	function __construct($host, $name, $pass, $table, $ut) {
		$this->host = $host;
		$this->name = $name;
		$this->pass = $pass;
		$this->table = $table;
		$this->ut = $ut;
		$this->connect();
		//mysql_query("SET CHARACTER SET utf-8");
		//mysql_query("SET NAMES utf8"); 

	}

	function connect() {
		$link = mysql_connect($this->host, $this->name, $this->pass) or die($this->error());
		mysql_select_db($this->table, $link) or die("database does't exist:" . $this->table);
		mysql_query("SET NAMES '$this->ut'");
	}

	function query($sql) {
		if (!($query = mysql_query($sql)))
			$this->show('Say:', $sql);
		return $query;
	}

	function show($message = '', $sql = '') {
		if (!$sql)
			echo $message;
		else
			echo $message . '<br>' . $sql;
	}

	function affected_rows() {
		return mysql_affected_rows();
	}

	function result($query, $row) {
		return mysql_result($query, $row);
	}

	function num_rows($query) {
		return @ mysql_num_rows($query);
	}

	function num_fields($query) {
		return mysql_num_fields($query);
	}

	function free_result($query) {
		return mysql_free_result($query);
	}

	function insert_id() {
		return mysql_insert_id();
	}

	function fetch_row($query) {
		return mysql_fetch_row($query);
	}

	function version() {
		return mysql_get_server_info();
	}

	function close() {
		return mysql_close();
	}

	//==============

	function fn_insert($table, $name, $value) {
		$this->query("insert into $table ($name) value ($value)");
	}

}

?>
